) Query PolicyYou can view the existing policies for the database by using the following statement:> SHOW RETENTION Policies on Telegrafname duration shardgroupduration replican DefaultDefault 0 168h0m0s 1 TrueAs you can see, Telegraf has only one policy, the meanings of each field are as follows:name--name, this example name is defaultduration--Duration, 0 means no LimitShardgroupduration--shardgroup storage time, Shardgroup is a basic storage structure of
when Influxdb saves data. Influxdb compares the local timestamp of the server with the timestamp of your data and removes older data than the one you set with duration in RPS. There can be multiple RPS in a single database, but RPS for each data is unique.Instance data: Db:food_datamesurement:ordersname: orders------------time phone website2016-05-10T23:18:00Z 10 30
Tags: php write pos uses the error BSP button to specify manual The HTTP API also has two operations: Write and query, this article first introduces you to the Influxdb HTTP API write operation mode.In the previous article on INFLUXDB study: The basic operation of INFLUXDB learning Influxdb, we mentioned that there are
Recently used in the InfluxDB, here to record the learning process, but also hope to help other students to learn.This paper mainly introduces the functional characteristics of INFLUXDB and the installation process of INFLUXDB. For more Influxdb detailed tutorials See: INFLUXDB
InfluxDB: InfluxDB http api Query
In the last article on InfluxDB: InfluxDB's InfluxDB http api write operation, we introduced the process of using InfluxDB's http api to write data, this article introduces how to use InfluxDB's http api to query data. For more details about Influx
Use python to operate InfluxDB and python to operate influxdb
Environment: CentOS6.5 _ x64InfluxDB version: 1.1.0Python: 2.6Preparations
Start the server
Run the following command:
service influxdb start
Example:
[root@localhost ~]# service influxdb startStarting influxdb
Tags: auth influxdb running his icon doc should group by ACKGrafana comes with a feature-rich data source plug-in influxdb. Supports rich query Editor, annotations, and templating (template) queries. Adding data sources (Adding the source)
Click the top Grafana icon to open the side menu.
In the Dashboards side menu under links, you should find a link called data sources.
Click on the but
Influxdb and traditional database in the concept of a lot of different, this article will give you some basic concepts in the INFLUXDB, more influxdb detailed tutorial see: INFLUXDB Series of Learning Tutorials DirectoryINFLUXDB Technology Group: 580487672 (click to join)Comparison with nouns in traditional database
InfluxDB is an open source distributed timing, event, and metrics database.Written in the Go language without external dependencies. Its design goal is to achieve distributed and horizontal scaling expansion.It has three main features:1. Time series (timeseries): You can use time-related functions (such as Max, Min, sum, etc.)2. Metrics (Metric): You can calculate large amounts of data in real time3. Eevents (Event): It supports arbitrary event dataCh
1
drop measurement disk_free
3. Data retention strategy (Retention policies)INFLUXDB does not provide a way to directly delete data records, but provides a data retention policy that is used primarily to specify the time to retain data, and to delete this part of the data over a specified time.
View current database retention policies
1
show retention policies on"db_name"
efficiently.Iii. InfluxDB data retention policy operations
1) query Policy
You can use the following statement to view the existing database policies:
> SHOW RETENTION POLICIES ON telegrafname duration shardGroupDuration replicaN defaultdefault 0 168h0m0s 1 true
As you can see, telegraf has only one policy. The meaning of each field is as follows:
Name -- name, which is default
Duration-duration, 0 indicates Unlimi
1) count () functionReturns the number of non-null values in an (field) field.Grammar:SELECT COUNT (Example:>select COUNT (water_level) from H2o_feetname:h2o_feet--------------time count1970-01-01t00:0 0:00z 15258Description Water_level This field has a total of 15,258 data in the H2o_feet table.Note: The function in Influxdb will default to epoch 0 (1970-01-01t00:00:00z) as time if no time is specified.You can add a time condition to the where, as fo
timestampinsert disk_free,hostname=server01 value=442221834240i 1435362189575692182Delete a tabledrop measurement disk_freeData Retention policy (Retention policies)INFLUXDB does not provide a way to directly delete data records, but provides a data retention policy that is used primarily to specify the time to retain data, and to delete this part of the data over a specified time.View current database retention policiesshow retention policies on cpu
Tags: flush table tor months Insert data lookup function max two pointsThis article is part of the series Influxdb series, which includes the following 15 parts:
influxdb to learn Influxdb installation and introduction
influxdb basic operation of learning Influxd
1) count () functionReturns the number of non-null values in an (field) field.Grammar:SELECT COUNT (Example:>select COUNT (water_level) from H2o_feetname:h2o_feet--------------time count1970-01-01t00:0 0:00z 15258Description Water_level This field has a total of 15,258 data in the H2o_feet table.Note: If the function in Influxdb does not have a specified time, it will default to epoch 0 ( 1970-01-01T00:00:00Z ) as the time.You can add a time condition
is: (2.116-2.064/(6m/12m)Calculates the rate of change for the maximum value every 12 minutes> SELECT derivative (MAX (water_level)) from H2o_feet WHERE location = ' Santa_monica ' and Time >= ' 2015-08-18t00:00:00Z ' and Time This function is very versatile, very complex, more detailed explanation of this function please crossing: https://docs.influxdata.com/influxdb/v0.13/query_language/functions/#derivative2) difference () functionEffect: Returns
Comparison with nouns in traditional database
Nouns in the nfluxdb
Concepts in a traditional database
database
database
measurement
table in the database
Points
A row of data inside the table
Second, the unique concept of INFLUXDB1) database--database, this database concept with traditional database.2) measurement--data Sheet, in Influxdb, measurement is the role
Summary of basic concepts of INFLUXDBInfluxdb as a time series database, compared with the traditional relational database, there are some differences, the following as far as possible in a simple and concise way to introduce the relevant terminology conceptsI. Basic CONCEPTS
MySQL
Influxdb
Description
Database
Database
Database
Table
Measurement
The concept of a table
Tags: readme.md open zhang Pat Hot add bar version-sharedThis is my previous INFLUXDB installation and configuration notes, recorded here, it is also convenient for me to check later. Environment: centos6.5_x64 Influxdb version: 1.1.0First, install 1, binary installationHere is an example of centos6.5 installation: wget https://dl.influxdata.com/influxdb/release
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.